<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html 
     PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <title>Module: Table</title>
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  <meta http-equiv="Content-Script-Type" content="text/javascript" />
  <link rel="stylesheet" href=".././rdoc-style.css" type="text/css" media="screen" />
  <script type="text/javascript">
  // <![CDATA[

  function popupCode( url ) {
    window.open(url, "Code", "resizable=yes,scrollbars=yes,toolbar=no,status=no,height=150,width=400")
  }

  function toggleCode( id ) {
    if ( document.getElementById )
      elem = document.getElementById( id );
    else if ( document.all )
      elem = eval( "document.all." + id );
    else
      return false;

    elemStyle = elem.style;
    
    if ( elemStyle.display != "block" ) {
      elemStyle.display = "block"
    } else {
      elemStyle.display = "none"
    }

    return true;
  }
  
  // Make codeblocks hidden by default
  document.writeln( "<style type=\"text/css\">div.method-source-code { display: none }</style>" )
  
  // ]]>
  </script>

</head>
<body>



    <div id="classHeader">
        <table class="header-table">
        <tr class="top-aligned-row">
          <td><strong>Module</strong></td>
          <td class="class-name-in-header">Table</td>
        </tr>
        <tr class="top-aligned-row">
            <td><strong>In:</strong></td>
            <td>
                <a href="../files/ex_rb.html">
                ex.rb
                </a>
        <br />
                <a href="../files/table_rb.html">
                table.rb
                </a>
        <br />
                <a href="../files/rbook_rb.html">
                rbook.rb
                </a>
        <br />
                <a href="../files/ansi_rb.html">
                ansi.rb
                </a>
        <br />
                <a href="../files/rtable_rb.html">
                rtable.rb
                </a>
        <br />
            </td>
        </tr>

        </table>
    </div>
  <!-- banner header -->

  <div id="bodyContent">



  <div id="contextContent">

    <div id="description">
      <p>
Module encapsulating the <a href="Table/RTable.html">RTable</a> api
</p>

    </div>


   </div>

    <div id="method-list">
      <h3 class="section-bar">Methods</h3>

      <div class="name-list">
      <a href="#M000026">abs_format</a>&nbsp;&nbsp;
      <a href="#M000029">ansi</a>&nbsp;&nbsp;
      <a href="#M000020">create_book</a>&nbsp;&nbsp;
      <a href="#M000019">do_excel</a>&nbsp;&nbsp;
      <a href="#M000023">fopen</a>&nbsp;&nbsp;
      <a href="#M000022">from_excel</a>&nbsp;&nbsp;
      <a href="#M000025">fstr</a>&nbsp;&nbsp;
      <a href="#M000027">get_color</a>&nbsp;&nbsp;
      <a href="#M000028">get_color_num</a>&nbsp;&nbsp;
      <a href="#M000021">make_sheet</a>&nbsp;&nbsp;
      <a href="#M000024">open</a>&nbsp;&nbsp;
      </div>
    </div>

  </div>


    <!-- if includes -->

    <div id="section">

    <div id="class-list">
      <h3 class="section-bar">Classes and Modules</h3>

      Class <a href="Table/RBook.html" class="link">Table::RBook</a><br />
Class <a href="Table/RTable.html" class="link">Table::RTable</a><br />

    </div>




      


    <!-- if method_list -->
    <div id="methods">
      <h3 class="section-bar">Public Class methods</h3>

      <div id="method-M000024" class="method-detail">
        <a name="M000024"></a>

        <div class="method-heading">
          <a href="Table.src/M000024.html" target="Code" class="method-signature"
            onclick="popupCode('Table.src/M000024.html');return false;">
          <span class="method-name">open</span><span class="method-args">(file)</span>
          </a>
        </div>
      
        <div class="method-description">
        </div>
      </div>

      <h3 class="section-bar">Public Instance methods</h3>

      <div id="method-M000026" class="method-detail">
        <a name="M000026"></a>

        <div class="method-heading">
          <a href="Table.src/M000026.html" target="Code" class="method-signature"
            onclick="popupCode('Table.src/M000026.html');return false;">
          <span class="method-name">abs_format</span><span class="method-args">(table,x,y)</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
Helper to get the <a href="Table.html#M000029">ansi</a> format string
quickly table =&gt; a <a href="Table/RTable.html">Table::RTable</a>
instance x =&gt; row y =&gt; column
</p>
        </div>
      </div>

      <div id="method-M000029" class="method-detail">
        <a name="M000029"></a>

        <div class="method-heading">
          <a href="Table.src/M000029.html" target="Code" class="method-signature"
            onclick="popupCode('Table.src/M000029.html');return false;">
          <span class="method-name">ansi</span><span class="method-args">(format=nil,*opts)</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
create <a href="Table.html#M000029">ansi</a> format and Spreadsheet::Format
for a cell *opts =&gt; see <a
href="Table/RTable.html#M000040">Table::RTable.color_xy</a>() or
smart_format() format =&gt; if a Spreadsheet::Format will modify instead of
create Returns array of [ansi_code,Spreadsheet::Format]
</p>
        </div>
      </div>

      <div id="method-M000020" class="method-detail">
        <a name="M000020"></a>

        <div class="method-heading">
          <a href="Table.src/M000020.html" target="Code" class="method-signature"
            onclick="popupCode('Table.src/M000020.html');return false;">
          <span class="method-name">create_book</span><span class="method-args">()</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
Creates and returns blank Spreadsheet::Workbook
</p>
        </div>
      </div>

      <div id="method-M000019" class="method-detail">
        <a name="M000019"></a>

        <div class="method-heading">
          <a href="Table.src/M000019.html" target="Code" class="method-signature"
            onclick="popupCode('Table.src/M000019.html');return false;">
          <span class="method-name">do_excel</span><span class="method-args">(name,table)</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
method to call from a <a href="Table/RTable.html">Table::RTable</a> returns
Spreadsheet::Worksheet of <a href="Table/RTable.html">RTable</a>
</p>
        </div>
      </div>

      <div id="method-M000023" class="method-detail">
        <a name="M000023"></a>

        <div class="method-heading">
          <a href="Table.src/M000023.html" target="Code" class="method-signature"
            onclick="popupCode('Table.src/M000023.html');return false;">
          <span class="method-name">fopen</span><span class="method-args">(file)</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
<a href="Table.html#M000024">open</a> a .rts file (a <a
href="Table/RBook.html">RBook</a>)
</p>
        </div>
      </div>

      <div id="method-M000022" class="method-detail">
        <a name="M000022"></a>

        <div class="method-heading">
          <a href="Table.src/M000022.html" target="Code" class="method-signature"
            onclick="popupCode('Table.src/M000022.html');return false;">
          <span class="method-name">from_excel</span><span class="method-args">(file)</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
Create a Spreadsheet::Workbook and <a
href="Table/RBook.html">Table::RBook</a> from a excel file Fill Worksheet
&#8216;s and <a href="Table/RTable.html">RTable</a> &#8216;s to respective
book from file file =&gt; the excel file path =&gt; string returns
[aRBook,aWorkbook]
</p>
        </div>
      </div>

      <div id="method-M000025" class="method-detail">
        <a name="M000025"></a>

        <div class="method-heading">
          <a href="Table.src/M000025.html" target="Code" class="method-signature"
            onclick="popupCode('Table.src/M000025.html');return false;">
          <span class="method-name">fstr</span><span class="method-args">(x,y)</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
lazy helper to make a format string x =&gt; row y =&gt; column
</p>
        </div>
      </div>

      <div id="method-M000027" class="method-detail">
        <a name="M000027"></a>

        <div class="method-heading">
          <a href="Table.src/M000027.html" target="Code" class="method-signature"
            onclick="popupCode('Table.src/M000027.html');return false;">
          <span class="method-name">get_color</span><span class="method-args">(ground,color)</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
get the <a href="Table.html#M000029">ansi</a> code for a color string,
color
</p>
        </div>
      </div>

      <div id="method-M000028" class="method-detail">
        <a name="M000028"></a>

        <div class="method-heading">
          <a href="Table.src/M000028.html" target="Code" class="method-signature"
            onclick="popupCode('Table.src/M000028.html');return false;">
          <span class="method-name">get_color_num</span><span class="method-args">(num,bf=nil)</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
get the english string of <a href="Table.html#M000029">ansi</a> code number
if bf != nil fore and background will be denoted
</p>
        </div>
      </div>

      <div id="method-M000021" class="method-detail">
        <a name="M000021"></a>

        <div class="method-heading">
          <a href="Table.src/M000021.html" target="Code" class="method-signature"
            onclick="popupCode('Table.src/M000021.html');return false;">
          <span class="method-name">make_sheet</span><span class="method-args">(book,name,table)</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
adds a Spreadsheet::Worksheet to a Spreadsheet::Workbook of a <a
href="Table/RTable.html">RTable</a> returns [book,sheet] (Spreadsheet::)
</p>
        </div>
      </div>


    </div>


  </div>


<div id="validator-badges">
  <p><small><a href="http://validator.w3.org/check/referer">[Validate]</a></small></p>
</div>

</body>
</html>